<Page id="1" templateExtension="html" relativePath="..\.." fullRelativePath=".\gharardad\user_part" secured="False" urlType="Relative" isIncluded="False" SSLAccess="False" wizardTheme="Coffee" wizardThemeType="File" needGeneration="0">
	<Components>
		<Grid id="2" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="199" connection="projectkar" dataSource="select project.name PR_NAME,contract.id contract_id,contract.name CON_NAME
from project,contract where
 project.use_id={CUSTOMER_ID}
and 
 contract.pro_id=project.id;" name="contracted_projects" pageSizeLimit="199" wizardCaption="List of PROJECT, CONTRACT " wizardTheme="Coffee" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Label id="8" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="PROJECT_NAME" fieldSource="PR_NAME" wizardCaption="PROJECT NAME" wizardTheme="Coffee" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Link id="14" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="CONTRACT_NAME" wizardTheme="Coffee" wizardThemeType="File" fieldSource="CON_NAME" hrefSource="see_contract_status_detail.ccp">
					<Components/>
					<Events/>
					<LinkParameters>
						<LinkParameter id="15" sourceType="DataField" name="CONTRACT_ID" source="CONTRACT_ID"/>
					</LinkParameters>
				</Link>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables>
				<JoinTable id="3" tableName="PROJECT" posWidth="100" posHeight="184" posLeft="10" posTop="10"/>
				<JoinTable id="5" tableName="CONTRACT" posWidth="100" posHeight="263" posLeft="220" posTop="34"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="7" fieldLeft="CONTRACT.PRO_ID" fieldRight="PROJECT.ID" tableLeft="CONTRACT" tableRight="PROJECT" conditionType="Equal" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="4" tableName="PROJECT" alias="PROJECT_NAME" fieldName="PROJECT.NAME"/>
				<Field id="6" tableName="CONTRACT" alias="CONTRACT_NAME" fieldName="CONTRACT.NAME"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="12" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
		<Grid id="10" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="199" name="not_contracted_projects" connection="projectkar" dataSource="select project.* from project where
 project.use_id={CUSTOMER_ID}
and 
 not exists(select * from contract where contract.pro_id=project.id);" pageSizeLimit="199" wizardCaption="List of PROJECT " wizardTheme="Coffee" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Label id="11" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="NAME" fieldSource="NAME" wizardCaption="NAME" wizardTheme="Coffee" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Link id="16" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="see_requests" wizardTheme="Coffee" wizardThemeType="File" hrefSource="see_requests_to_write.ccp">
					<Components/>
					<Events/>
					<LinkParameters>
						<LinkParameter id="18" sourceType="DataField" name="PROJECT_ID" source="PRO_ID"/>
					</LinkParameters>
				</Link>
				<Link id="17" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="choose_member" wizardTheme="Coffee" wizardThemeType="File" hrefSource="choose_member_for_writing.ccp">
					<Components/>
					<Events/>
					<LinkParameters>
						<LinkParameter id="19" sourceType="DataField" name="PROJECT_TO_WRITE" source="PRO_ID"/>
					</LinkParameters>
				</Link>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables/>
			<JoinLinks/>
			<Fields/>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="13" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
	</Components>
	<CodeFiles>
		<CodeFile id="Model" language="JSP" name="see_my_projects_to_want.xml" path="." comment="&lt;!--" commentEnd="--&gt;" codePage="iso-8859-1" forShow="False"/>
		<CodeFile id="JSP" language="JSP" name="see_my_projects_to_want.jsp" path="." comment="&lt;%--" commentEnd="--%&gt;" codePage="iso-8859-1" forShow="True" url="see_my_projects_to_want.jsp"/>
		<CodeFile id="Handlers" language="JSP" name="see_my_projects_to_wantHandlers.jsp" path="." comment="//" codePage="iso-8859-1" forShow="False"/>
	</CodeFiles>
	<SecurityGroups/>
	<Events/>
</Page>
